UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1gTkA0dmTE7zhT8OGpwBe1wMJSxb6435KQdOgleZNb0='
WHERE
key_id = '3735537ff3238d7dad26de605806fb9c61b49cfb97b6b9eeb9201a52391d6f3c'
AND (
token = '1gTkA0dmTE7zhT8OGpwBe1wMJSxb6435KQdOgleZNb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)