UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2/pVXFAIbGWSUz5kcxoH39VtU1jLVYDkx4JiRrjj2mo='
WHERE
key_id = 'b9d096b7b318a95c3e7534c730a5dc817e391f9d815cdeaab1f143c95390ef97'
AND (
token = '2/pVXFAIbGWSUz5kcxoH39VtU1jLVYDkx4JiRrjj2mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)