UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06/PNf0KvlGD1hsf2JghpS2mvr9Ma6+PyyMcVRdlkL4='
WHERE
key_id = 'ccc2d2669341e50a8dcd9b9babb53ce199f8972a10097b7bde7f3a38ef34d98a'
AND (
token = '06/PNf0KvlGD1hsf2JghpS2mvr9Ma6+PyyMcVRdlkL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)