UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NE/G4E1oA8AsmgDrjMj/2k0awos9NNr/OXv3HKx66D4='
WHERE
key_id = '259368b864d9dea3415544c82485c9c13468870c0dfe0ec66fd9427885fe98b3'
AND (
token = 'NE/G4E1oA8AsmgDrjMj/2k0awos9NNr/OXv3HKx66D4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)