UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KjpJh/WcHDWu43+oGE/bUU1uSNIFOgG0D1D1reqBHrw='
WHERE
key_id = '1bfe3a08c46495266f49dfec79963d87b16a345316020ceaaf65741861507bc8'
AND (
token = 'KjpJh/WcHDWu43+oGE/bUU1uSNIFOgG0D1D1reqBHrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)