UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/46SvYy/lPVb8GfjdL5yBPIFYvAal0LF9nUhgZrXamA='
WHERE
key_id = '7f48e816cfac3ade392f60f39ad1518c69f9cb4089afab8c859920623460fa8c'
AND (
token = '/46SvYy/lPVb8GfjdL5yBPIFYvAal0LF9nUhgZrXamA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)