UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tff+l0IgtI1WW56DLbrAxtFBZ6k9NYIBWjT++Us5+I8='
WHERE
key_id = 'a648336799031bd9ac70b6287aff3da87437081b69d49a4fa191f6ea968f75af'
AND (
token = 'Tff+l0IgtI1WW56DLbrAxtFBZ6k9NYIBWjT++Us5+I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)