UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ii5cdHknKQk/sybxIFSiub3NcRLcqfiJmvhmz1IduJI='
WHERE
key_id = 'd3a88d1046ad03e7827d5eeafb4fbf8684432867c5f68d4386145777a2952e9b'
AND (
token = 'Ii5cdHknKQk/sybxIFSiub3NcRLcqfiJmvhmz1IduJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)