UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5zD2awDU8EdaRm0vbcu2QxwLiEhA2T3TmeOKy+5GtpU='
WHERE
key_id = '36b69b115dc6a2eef73624321d02218f5620d37986cfa523d05404607859461c'
AND (
token = '5zD2awDU8EdaRm0vbcu2QxwLiEhA2T3TmeOKy+5GtpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)