UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4nXQxZqtnj1QspqQOukmursaA75j7wirGwxUJNMPxp4='
WHERE
key_id = '4b6c638c8a78ce109a99758d8c673d70bb9bc845275a17b873635ade1ee3ce9f'
AND (
token = '4nXQxZqtnj1QspqQOukmursaA75j7wirGwxUJNMPxp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)