UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uYHroU7zgwazYS5WzqPUTzWk0RsbZbAiBaRiM87bHdk='
WHERE
key_id = '7d63274b4292e917cb9df473f59803d38b85ee9af737f98d31d537c28b359a7a'
AND (
token = 'uYHroU7zgwazYS5WzqPUTzWk0RsbZbAiBaRiM87bHdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)