UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qf/nUxxnnA1wWVf6SQZGMz6G+cTeNNCJeLxM5VI4HG8='
WHERE
key_id = 'a8183cfd45a9c0dae66f152355180ad22095129457b15bbcab030f7add2bd350'
AND (
token = 'Qf/nUxxnnA1wWVf6SQZGMz6G+cTeNNCJeLxM5VI4HG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)