UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+qWK1S12J4Z6CJgMb1NapK08r+wifsnFzr1JLY79YQA='
WHERE
key_id = 'ca4078b1c2a6f4d24cac6e7c6358a1172eaafbd0e780e4852761d5cc7b7ff58b'
AND (
token = '+qWK1S12J4Z6CJgMb1NapK08r+wifsnFzr1JLY79YQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)