UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e6eHrIOkfSrz1JGyD3G64H8H0JqP+sNzDW/kwuSN2pA='
WHERE
key_id = '2578b9cf8f7353ba37fde6e659632d81608c2a02e86ee0795310d479be3e78bf'
AND (
token = 'e6eHrIOkfSrz1JGyD3G64H8H0JqP+sNzDW/kwuSN2pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)