UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzBnnMJCNJiZOWyWTmXSaA95XA8I7WrZhHVd1Hv2opM='
WHERE
key_id = '21777f4d395e4c6f9190d13925d59e23fb46913ad5ea193b8ab101a52f378054'
AND (
token = 'XzBnnMJCNJiZOWyWTmXSaA95XA8I7WrZhHVd1Hv2opM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)