UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zd1gvieJOTq+WEBzqy/DIMqUXu3Sgftq62JkYYx2ebY='
WHERE
key_id = '6e3ffd982ab5fabe90c7df8e0684bd17a37d82a3b4f7a22f791494c53069021a'
AND (
token = 'zd1gvieJOTq+WEBzqy/DIMqUXu3Sgftq62JkYYx2ebY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)