UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BXKUCBlgpTtPVbno+irXDmb+tU/gBLRvhL9RKQoRV4='
WHERE
key_id = '0477cd9fb3906580e3349668492e8bede48f958b4db24c057c45ec5256183371'
AND (
token = '8BXKUCBlgpTtPVbno+irXDmb+tU/gBLRvhL9RKQoRV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)