UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iTnbBk2yZq1ykyGQjKLUeA38RM5ECHu1cDo0Zt5JKE4='
WHERE
key_id = 'f828e204c2f9bf19b9320fe5c48731112d145619333c64754aaeda1fe0afbb1f'
AND (
token = 'iTnbBk2yZq1ykyGQjKLUeA38RM5ECHu1cDo0Zt5JKE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)