UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w0J6oWNX7OLu1DcjOoEeWVLinHrt7bEvyT9Oq4lxPG8='
WHERE
key_id = '0763016ed7ae1f00b9f876e9a219e0a349be45d3f04adb73eab19ee884ca04a2'
AND (
token = 'w0J6oWNX7OLu1DcjOoEeWVLinHrt7bEvyT9Oq4lxPG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)