UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yqra8f3IEikfUZjTVs0RY7teGjlBkYauKwRjSnhVofg='
WHERE
key_id = '5bace81e788943a73a71a90a46951393c2e0174886fd88c620dfbf2d67ab9183'
AND (
token = 'yqra8f3IEikfUZjTVs0RY7teGjlBkYauKwRjSnhVofg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)