UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hXXX6grLtBjpR71UviV0dLE3BHB579KXYj96clzhzQg='
WHERE
key_id = 'd64e1b0daf247074d31d4f863ab7fc620b77aae310ea4f066e25aabaec4fb525'
AND (
token = 'hXXX6grLtBjpR71UviV0dLE3BHB579KXYj96clzhzQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)