UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm6cDoHFmSJ2xRrXcze79gn6ZORCOFebsf4ynI11k2cA='
WHERE
key_id = '4a000c39792543d2a3176a1dc82dde3db003bd45f8d909161d668fb7575d8b57'
AND (
token = 'm6cDoHFmSJ2xRrXcze79gn6ZORCOFebsf4ynI11k2cA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)