UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cDyZzuDqb6wZCc+VxR3sAN8FKteLzQYaZjIIBaxxoTw='
WHERE
key_id = '42ac1d8a680887638696ffd8370ce141f5dfdc1d0e36401a948d75d6e051dc40'
AND (
token = 'cDyZzuDqb6wZCc+VxR3sAN8FKteLzQYaZjIIBaxxoTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)