UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xc9prrhZqKK5JrB5Cj2FkmaRCkKFIe2fmLjjiOKhaEA='
WHERE
key_id = '3014f7ddad173e55b00cabdc2cab08df74d16c3de20ab62031488a207b962aca'
AND (
token = 'Xc9prrhZqKK5JrB5Cj2FkmaRCkKFIe2fmLjjiOKhaEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)