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