UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uKZTRovOgUUdwUeScmrA8yA6kf15Q2Qf/zgGp8QY7R8='
WHERE
key_id = '6cac1e7f23bb8610e7d0f393f913f4e2ef9c6cec3ae2da6d1fe172cd4b1e904f'
AND (
token = 'uKZTRovOgUUdwUeScmrA8yA6kf15Q2Qf/zgGp8QY7R8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)