UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VMZptVgH4LuBxd2L0nxlACNnFs61itllh5vyvpmfXU='
WHERE
key_id = '4d534ebbcd21d86c64231d01e9498309c53a32b1785f4f3506c21ffc5a8b2472'
AND (
token = '9VMZptVgH4LuBxd2L0nxlACNnFs61itllh5vyvpmfXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)