UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zoecWzUDqFkcwrPJJR9qi0UIo+4Eh7gPAEkYuwMCEc4='
WHERE
key_id = '2a0d5e131c4b8dbd2c3119557bba18a54176e8867ee733f5acb88a390ed29174'
AND (
token = 'zoecWzUDqFkcwrPJJR9qi0UIo+4Eh7gPAEkYuwMCEc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)