UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XsKtoeqY1rXoza/6tu/IGGByOohHQMTiYdQjulzkZQ0='
WHERE
key_id = 'bd80f800876044fcca1af10eb671f4bd997cad9f1b14ad4de7695453102b8d62'
AND (
token = 'XsKtoeqY1rXoza/6tu/IGGByOohHQMTiYdQjulzkZQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)