UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gfYY3yTXNq+mLiZAsASsRuBScRubxB3VlMRQvqietQc='
WHERE
key_id = '03e786896a5ba3ad1f3466aa251f0fa75b0eea0a3ffbcd19b42f5c4e83c4c3cf'
AND (
token = 'gfYY3yTXNq+mLiZAsASsRuBScRubxB3VlMRQvqietQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)