UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ym7BaLL8NjHXLLiNr046KbmQYQbNLFQ3tahc8VsEsz8='
WHERE
key_id = '19b49c2c1742e5953fb75d6fbf75e05cd7d4eda2abcd6aae9d5302dc5fbdb2ef'
AND (
token = 'Ym7BaLL8NjHXLLiNr046KbmQYQbNLFQ3tahc8VsEsz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)