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