UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JUX+Kyz7kyG6r24enQNJAjhXMySP10shuSlQ3LGQv/w='
WHERE
key_id = '589411be631d8e4f1b871ecda4d075bcf5dc37677586139da616f4d80c72f720'
AND (
token = 'JUX+Kyz7kyG6r24enQNJAjhXMySP10shuSlQ3LGQv/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)