UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XGxks4YLNunTQBmjPunlTsIb6zI6KaAnFKjOo+fJCI='
WHERE
key_id = '38c3bff3537e6e8e63050251b434a8e9ef8d4cdc9f05a12661360d4e14c4b46c'
AND (
token = '/XGxks4YLNunTQBmjPunlTsIb6zI6KaAnFKjOo+fJCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)