UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29skLFHhvBRyVX+A8xbAdmA44SNy0N3u0HFJ73d6iO0='
WHERE
key_id = '589cbf3861ab52332d455e0d2817fd0de21b6ab5183e6ccf51a5b093c7a242cb'
AND (
token = '29skLFHhvBRyVX+A8xbAdmA44SNy0N3u0HFJ73d6iO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)