UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mn5sDpXNiOzInwsxJb/WwPcMCPn9rXu4h4NzdL2pKRw='
WHERE
key_id = '27e89ede1cd54b9d693a3220b3bbbca27f8167076672610a3a56daf4b82736a9'
AND (
token = 'mn5sDpXNiOzInwsxJb/WwPcMCPn9rXu4h4NzdL2pKRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)