UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9lQ8JiDRF7BA6E9E0aR0MXXdcGE+b/PIi4Bv1d2hnzk='
WHERE
key_id = 'b85a9de38c4ea2132a9cc68311893645812237cdb8ecd3224dcf86eea78ccc45'
AND (
token = '9lQ8JiDRF7BA6E9E0aR0MXXdcGE+b/PIi4Bv1d2hnzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)