UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXMq2iYqUZwHJy71DM3DuIqkgLzGalRZGhbz7wpy8qs='
WHERE
key_id = 'cf24b4c96dd419fd686474f3cbbfca569691ad4acedce51ae7cb4994fc770286'
AND (
token = 'pXMq2iYqUZwHJy71DM3DuIqkgLzGalRZGhbz7wpy8qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)