UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pOn0kPzjmOi9eMwNS824mX8yDDf3QdcpYqw4pLuAPfE='
WHERE
key_id = 'f1ed606443f1b93c1318623a26be8f17f26f369b17622abba7503fc185a374e5'
AND (
token = 'pOn0kPzjmOi9eMwNS824mX8yDDf3QdcpYqw4pLuAPfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)