UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sqyJJmP+wSKEu08Qof+FIprdXr6yDddo64Xkh1e7W/I='
WHERE
key_id = '6553b65a396ad8dc38192507f4888ba8e80c11613e5e90982a49f92b38fb7433'
AND (
token = 'sqyJJmP+wSKEu08Qof+FIprdXr6yDddo64Xkh1e7W/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)